Technote Number: 1099597
Problem:
This issue was reported to Quality Engineering and has been addressed in Domino
5.0.3.
This is actually an issue with the stored procedure; DECS is functioning as
designed.
Workaround: Use a stored procedure written in SQL.
Supporting Information:
When creating a SQLRPGLE stored procedure that will be used by DECS on the
AS/400, it is important to define the format of the parameter(s) that the
stored procedure passes to the DB/2 table, according to the field definitions
in the Notes NSF file. It is also important to note that the type of parameter
DECS passes to the stored procedure is the type of the key defined in the Notes
database, not what is defined in DB/2.
Example: You attempt to pass a field that is defined as type FLOAT in the .NSF
file, to a DB/2 table record that is defined as type NUMERIC. The SQLRPGLE
stored procedure must define its input data as type FLOAT. If it is not
defined to match what the .NSF file is presenting to it, the stored procedure
will pass the input data directly to the DB/2 table. If the definitions do not
match, then the data will appear as "garbage". More >
|  |
|
|
|
|
|